﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using MixScript.DBService;
using MixScript.BLL;


namespace MixScript.BLL.MM
{
    public class cStock : cBaseBLL
    {

        public cStock()
        {

        }

        public DataTable getStock(string sdate)
        {
            try
            {
                DataTable dt= new DataTable();
                string sql="select * from vw_rptstock where year(ocdt)="+sdate.Substring(6,4)+" and month(ocdt)="+sdate.Substring(3,2);
                dt = Dbserver.ExecuteQuery(sql, "vw_rptstock");
                return dt;

            }
            catch (Exception ex)
            {

                throw ex;
            }

        }
        

    }
}
